Quiz: Calculated Fields

Task Description:

Tasks to complete:

Task List:

Assure you are on a new worksheet.

From the Profit drop down, select Create > Calculated Field....

Change Calculation1 to Profit per Item, and the equation to [Profit]/[Quantity]. Name this Profit per Item. Hit OK.

Notice your new column exists within the measures.

Move Profit per Item to the Columns, and change to AVG aggregator. Move Sub-Category to the Rows.

Quiz 1 below.

Assure you are on a new worksheet.

From the Quantity drop down, select Create > Calculated Field....

Change Calculation1 to Quantity Factor, and complete Quizzes 2 and 3 below to assist with the statement you will write next.

Quiz 2 below.

Quiz 3 below.

Write an IIF Statement for 'High', 'Medium', and 'Low' categories of Quantity Factor with cutoffs at 3 and 8.

Move the Quantity Factor to the Rows and Category to the Columns.

In the drop down menu on Quantity Factor select Measure > count.

Move another Quantity Factor to the Columns. My image is at the bottom for your reference.

Quiz 4 below.

Task Feedback:

Nice job!

QUIZ QUESTION::

Quiz 1

Move each Sub-Category item to its corresponding description.

ANSWER CHOICES:

Description	Sub-Category
This item is the lowest profiting item while still being positive.
On this Item we make an average profit of 11.72.
This is our highest profit/item item.
This is our lowest profit/item item.

SOLUTION:

Description	Sub-Category
On this Item we make an average profit of 11.72.
This is our highest profit/item item.
This is our lowest profit/item item.
This item is the lowest profiting item while still being positive.

QUIZ QUESTION::

Quiz 2

For the calculated field of IIF([Quantity] < 2, 'Low', 'High') match the following values to their corresponding result.

ANSWER CHOICES:

Value	Result
1
3
2
-1

SOLUTION:

Value	Result
1
-1
1
-1
3
2
3
2

QUIZ QUESTION::

Quiz 3

For the calculated field of IIF([Quantity] < 2, 'Low', IIF([Quantity] < 5, 'Medium', 'High')) match the following values to their corresponding result.

ANSWER CHOICES:

Value	Result
1
3
2
8
-1

SOLUTION:

Value	Result
1
-1
3
2
8
1
-1
1
-1
3
2
3
2

SOLUTION:

Most orders have between 3 and 8 items sold.